UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6LGWDLD1CL+YAGym5n9d4RxdY4ZD+Ea/j2Wfy26REL4='
WHERE
key_id = '58d4861a8fc0d31ea926768cff81849fecc913022f4397b4c489f415ac08f29c'
AND (
token = '6LGWDLD1CL+YAGym5n9d4RxdY4ZD+Ea/j2Wfy26REL4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)