UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzf7h9ESHclZ1UIUhcUttjOm19z0zFNYUwIsMY3kUxM='
WHERE
key_id = '01a4eafa2170c95b15ab3016f1ccbdc902912652af2a4b16b7f395a316e707f7'
AND (
token = 'pzf7h9ESHclZ1UIUhcUttjOm19z0zFNYUwIsMY3kUxM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)