UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MWJi83+kqITQG+IKYbmx+OxKlkkrE8ztmvEcEeSM2I4='
WHERE
key_id = 'ec6aee647e852b4e49ad65f6432fe4f6aecce7b414fc16f1763ab2636a3eb815'
AND (
token = 'MWJi83+kqITQG+IKYbmx+OxKlkkrE8ztmvEcEeSM2I4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)