UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LogICFemonBmpPoY/xnDTrNazujXkrm1fRpVDTe8ui0='
WHERE
key_id = '593a948b020e7bebab2f93647b847bb4df7e68f35413db28dc98d6aeab42a6e0'
AND (
token = 'LogICFemonBmpPoY/xnDTrNazujXkrm1fRpVDTe8ui0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)