UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1L1bTb2rSpHFAZU41XMx6xdyH4T3Rwmauc1eN2SvH8='
WHERE
key_id = 'e1d041c59e22eb95bce5ff8d0814629233764d2bf358d62f82301088400d379a'
AND (
token = '/1L1bTb2rSpHFAZU41XMx6xdyH4T3Rwmauc1eN2SvH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)