UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yQ3q8L2PHyTwXn4PA9hTbS/b5uUCN/Pq0SClR5Q6fQw='
WHERE
key_id = '4b86b47bf49a07c54dee4cf4085eeb403d1cce7304b2a424ff7fa75e52ec5b6c'
AND (
token = 'yQ3q8L2PHyTwXn4PA9hTbS/b5uUCN/Pq0SClR5Q6fQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)