UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V6mOJZr2lNzn6KEHYKO3et41stb8AB9XNkIJSo1coig='
WHERE
key_id = 'd9eada47e07832c939989587279eb2f00c7f7e407f9e8ba5f98f13c6eec6f805'
AND (
token = 'V6mOJZr2lNzn6KEHYKO3et41stb8AB9XNkIJSo1coig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)