UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2oWAHL8gfYnSqJE+PPwbdIWCcvRVlcw0407b2PqkPtc='
WHERE
key_id = 'ecdfb983ef7b5adb063d7d55fecf26fcc87a8b947a7723407134f9375916943b'
AND (
token = '2oWAHL8gfYnSqJE+PPwbdIWCcvRVlcw0407b2PqkPtc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)