UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7iFGWsjUuj0OJCcckiklTZ1rmhVYshdAChHkxJ7D/nE='
WHERE
key_id = '587f11f4e638932a639c1afc9ac288fc7445bd3dd02c2d227dc69ad21ca06fbb'
AND (
token = '7iFGWsjUuj0OJCcckiklTZ1rmhVYshdAChHkxJ7D/nE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)