UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YBYszb0NHRGLj9gtTQ9vFPp24cm0gf4TuBlMEiu0vQE='
WHERE
key_id = '9f1d2717045464a6b57ae268da988b006778d0e686b04d3202966977a1c5966e'
AND (
token = 'YBYszb0NHRGLj9gtTQ9vFPp24cm0gf4TuBlMEiu0vQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)