UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S8s1AwtKreaO534AV3CNsGbmkvajGnp7hRwsQPL+xbk='
WHERE
key_id = 'd14dbbbec53d0ef9da9f98f008afaebf56573e652e7146f815cba5e7139f880f'
AND (
token = 'S8s1AwtKreaO534AV3CNsGbmkvajGnp7hRwsQPL+xbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)