UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xEy2KbY5qEhJOWch2b1IF+xGhdWrj5ZB+1Jy1+xEgt0='
WHERE
key_id = '1b3f8a418001fd651a975b7638b2f8efdf3faf187f8fbec42b87f882fc659f02'
AND (
token = 'xEy2KbY5qEhJOWch2b1IF+xGhdWrj5ZB+1Jy1+xEgt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)