UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jGWt5JEeYIVRm1LBTY5IsPQZvGdo6wy/FtCUooAZC4I='
WHERE
key_id = '249ed5a6e8d356b41c0b40c8911fef363aaa90df3fc5f25859889cac12cb97cf'
AND (
token = 'jGWt5JEeYIVRm1LBTY5IsPQZvGdo6wy/FtCUooAZC4I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)