UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'y9bK5DPvvdeoZBAwAOl5YjeZ9IVVnu462yLPyQx5fcc='
WHERE
key_id = 'e0cb4520dc176df9fbbd380e144100e18955ddd1174c36c2a97e82068b8f928f'
AND (
token = 'y9bK5DPvvdeoZBAwAOl5YjeZ9IVVnu462yLPyQx5fcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)