UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dnTwoxhmpO9h24d1L0vhMT64UjvkpZ0BKy7agf0y+/8='
WHERE
key_id = '847bf199c36ffb5a1517f656ed7b162b98596d53584621d97f6030518d7ef348'
AND (
token = 'dnTwoxhmpO9h24d1L0vhMT64UjvkpZ0BKy7agf0y+/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)