UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xLPzd7I8cINxZ9/lYoU2jZBzDuFJpudM8Ee78gJ5MZI='
WHERE
key_id = 'abace44326e5b02a8a1acb461f0ab24f59849d23b30ba4e72f293fad93bca184'
AND (
token = 'xLPzd7I8cINxZ9/lYoU2jZBzDuFJpudM8Ee78gJ5MZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)