UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGaE7q8B7hC98r/rZYkc2ig1jhkaDtNERI6gdw3dSJw='
WHERE
key_id = 'a951412b0d71580dd9ab5e55b2c955ca8ad78683ad88ab49b2e52613e54cd184'
AND (
token = 'HGaE7q8B7hC98r/rZYkc2ig1jhkaDtNERI6gdw3dSJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)