UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fFkPNO4pWeRfAhWKMwh2PtskQ8AiQd9fwiyigyBlzuE='
WHERE
key_id = '3a42919fa0488ad29b2ef8a8c618d04ccdb7daf0f3ebd8526f45313c7aa44db9'
AND (
token = 'fFkPNO4pWeRfAhWKMwh2PtskQ8AiQd9fwiyigyBlzuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)