UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CpUDeYCiAmo0GY5944gqeMa3o+CilWaRYEyWHYbZjNA='
WHERE
key_id = '59583c68cd7ace0590c21c09c80f7686adee2684eb80b7f20d2f35b181d08d4f'
AND (
token = 'CpUDeYCiAmo0GY5944gqeMa3o+CilWaRYEyWHYbZjNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)