UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QG1nuosYVH0LaRo/pwvvIsOC6Fui3oLcxbFjsvtb00w='
WHERE
key_id = 'd3f4125bb4dde817edeb5471ec09502ac01d6f9dabe6b8fb18e18f667ae52673'
AND (
token = 'QG1nuosYVH0LaRo/pwvvIsOC6Fui3oLcxbFjsvtb00w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)