UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GcJUOro3YBf74AjCEFHJ3KstZebm4ZmGHIREC2lf9TI='
WHERE
key_id = 'ec0fa7d61952f417fc45e2a7996bb5b6f3a4fb3dbfcc91c7ce582499aefa23a7'
AND (
token = 'GcJUOro3YBf74AjCEFHJ3KstZebm4ZmGHIREC2lf9TI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)