UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'APPtfDEwzXNaM9qLMS+6Tx77ZjNcEJcmimH25DansTM='
WHERE
key_id = '7378fb86a25f6cf6d79553c207f791fa33a0063b375c11a43af9b94cc128f50b'
AND (
token = 'APPtfDEwzXNaM9qLMS+6Tx77ZjNcEJcmimH25DansTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)