UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HUS9GCZ2efdIJUJm0TptM0+8KoFdZUCb2xrZ04fC2rU='
WHERE
key_id = 'c86984d3d9f7f34684ffbce84e60f5e68291ddf0d0818dd4919aca22fc732e5b'
AND (
token = 'HUS9GCZ2efdIJUJm0TptM0+8KoFdZUCb2xrZ04fC2rU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)