UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SsvQkS1/EHn7ZW2jEWkD/TE0vmITXe1XFQrpWAqC+vg='
WHERE
key_id = '7747a46ec2b1b1bb7885b761c5ba4e2417c14547003de6a58e2b32e95615b173'
AND (
token = 'SsvQkS1/EHn7ZW2jEWkD/TE0vmITXe1XFQrpWAqC+vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)