UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'En0J0y50SqGRfbCbU9BNDIbF/41oWvaNI28iurmKnjg='
WHERE
key_id = 'bda6f56850e33604ddec67703dca8488e43b0617720ae67a40456bfb05559194'
AND (
token = 'En0J0y50SqGRfbCbU9BNDIbF/41oWvaNI28iurmKnjg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)