UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQ5h5guHUTgTYB+lEmiAcGgrU8Y/GbM0VSNq8Rrzwro='
WHERE
key_id = '5d12d993e0c1ba52a9b2bd345ea874bf9a5e8add7d8b13fdcd6a6fa059675ac9'
AND (
token = 'xQ5h5guHUTgTYB+lEmiAcGgrU8Y/GbM0VSNq8Rrzwro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)