UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SIfUxgxGzMfrJ+brXgzFNPzHlYzCXE+MydMkHfHDBMo='
WHERE
key_id = '16d42e6b286bdb10b237a2bb31786d742b71cb8806721533f75894cc2cc300ab'
AND (
token = 'SIfUxgxGzMfrJ+brXgzFNPzHlYzCXE+MydMkHfHDBMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)