UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/7ia/6gJOwEYXkFepWJBiIMwwpMsCEF8jKDTY+6FweE='
WHERE
key_id = '9be494aff5033fe13836340259b508f8684872d8cb1f45cbf06f0914bed86aba'
AND (
token = '/7ia/6gJOwEYXkFepWJBiIMwwpMsCEF8jKDTY+6FweE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)