UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAF5Axauw3Z1i9n5myYLNl9Wq9rl5/T4WXLNm8nQQKA='
WHERE
key_id = 'c98b7d95e7b988a62a02c4147fee342a8a99ea6bfd17d6609d7cdee29370037d'
AND (
token = 'hAF5Axauw3Z1i9n5myYLNl9Wq9rl5/T4WXLNm8nQQKA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)